CREATE PROCEDURE dbo.LeadCommentInsertModel
	@LeadKey INT,
	@Comment NVARCHAR(MAX),
	@Audit_UserKey INT
AS
	SET NOCOUNT ON

	INSERT INTO dbo.LeadComment (
		LeadKey,
		Comment,
		CreatedByKey,
		CreatedDate,
		UpdatedByKey,
		UpdatedDate
	) VALUES (
		@LeadKey,
		@Comment,
		@Audit_UserKey,
		GetDate(),
		@Audit_UserKey,
		GetDate()
	)

	DECLARE @LeadCommentKey INT = Scope_Identity()
	EXEC dbo.LeadCommentSelectModel @LeadCommentKey = @LeadCommentKey, @Audit_UserKey = @Audit_UserKey

RETURN 0
